x is the Number for which you want the Absolute Value returned.
Abs returns the value of x, ignoring any negative values.
If Abs(37 - {file.FIELD}) > 1 Then
formula = "Maintenance, Temperature Check"
If Abs(37 - {file.FIELD}) > 1 Then
"Maintenance, Temperature Check"
This flags instances where a laboratory heat block has a temperature variation greater than +/- 1 degree C.
This function is designed to work like the Visual Basic function of the same name.
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |